package com.showde.shoppingmall.db.constant;

public class ProductDescConstant extends ConstantBase {

	public static final String TABLENAME = "t_productdesc";

	public static final String PRODUCTDESCID = "PRODUCTDESCID"; // 商品id
	public static final String PRODUCTDESCNAME = "PRODUCTDESCNAME"; // 商品名称
	public static final String PRODUCTDESCTITLE = "PRODUCTDESCTITLE"; // 商品标题
	public static final String PRODUCTDESCPRICE = "PRODUCTDESCPRICE"; // 商品价格
	public static final String PRODUCTDESCVIPPRICE = "PRODUCTDESCVIPPRICE"; // 商品vip价格
	public static final String PRODUCTDESCMPRICE = "PRODUCTDESCMPRICE"; // 商品m价格
	public static final String PRODUCTDESCNUM = "PRODUCTDESCNUM"; // 商品库存
	public static final String PRODUCTDESCDESC = "PRODUCTDESCDESC"; // 商品描述信-html格式
	public static final String PRODUCTDESCLOGO = "PRODUCTDESCLOGO"; // 商品logo
	public static final String PRODUCTDESCSIZES = "PRODUCTDESCSIZES"; // 商品尺码
	public static final String PRODUCTDESCCOLORS = "PRODUCTDESCCOLORS"; // 商品颜色
	public static final String PRODUCTDESCISOUTOFSTACK = "PRODUCTDESCISOUTOFSTACK"; // 商品是否下架
	public static final String PRODUCTDESCPOSTFEE = "PRODUCTDESCPOSTFEE"; // 商品邮费
	public static final String PRODUCTCATEGORYID = "PRODUCTCATEGORYID"; // 商品所属类别

	public static final int COLUMN_PRODUCTDESCID = 1; // 商品id
	public static final int COLUMN_PRODUCTDESCNAME = 2; // 商品名称
	public static final int COLUMN_PRODUCTDESCTITLE = 3; // 商品标题
	public static final int COLUMN_PRODUCTDESCPRICE = 4; // 商品价格
	public static final int COLUMN_PRODUCTDESCVIPPRICE = 5; // 商品vip价格
	public static final int COLUMN_PRODUCTDESCMPRICE = 6; // 商品m价格
	public static final int COLUMN_PRODUCTDESCNUM = 7; // 商品库存
	public static final int COLUMN_PRODUCTDESCDESC = 8; // 商品描述信息 html格式
	public static final int COLUMN_PRODUCTDESCLOGO = 9; // 商品logo
	public static final int COLUMN_PRODUCTDESCSIZES = 10; // 商品尺码
	public static final int COLUMN_PRODUCTCOLORS = 11; // 商品颜色
	public static final int COLUMN_PRODUCTDESCISOUTOFSTACK = 12; // 商品是否下架
	public static final int COLUMN_PRODUCTDESCPOSTFEE = 13; // 商品邮费
	public static final int COLUMN_PRODUCTCAREGORYID = 14; // 商品所属类别

	public static final String[] dbColumns = new String[] { PRODUCTDESCID,
			PRODUCTDESCNAME, PRODUCTDESCTITLE, PRODUCTDESCPRICE,
			PRODUCTDESCVIPPRICE, PRODUCTDESCMPRICE, PRODUCTDESCNUM,
			PRODUCTDESCDESC, PRODUCTDESCLOGO, PRODUCTDESCSIZES,
			PRODUCTDESCCOLORS, PRODUCTDESCISOUTOFSTACK, PRODUCTDESCPOSTFEE,
			PRODUCTCATEGORYID };

	public static final String SQL_CREAT = "create table 't_productdesc'("
			+ "'_id' int primary key, "
			+ "'PRODUCTDESCID' varchar(20) not null unique, "
			+ "'PRODUCTDESCNAME' varcchar(40),"
			+ "'PRODUCTDESCTITLE' varchar(100), "
			+ "'PRODUCTDESCPRICE' float, " + "'PRODUCTDESCVIPPRICE' float, "
			+ "'PRODUCTDESCMPRICE' float, " + "'PRODUCTDESCNUM' int , "
			+ "'PRODUCTDESCDESC' text, " + "'PRODUCTDESCLOGO' varchar(200), "
			+ "'PRODUCTDESCSIZES' varchar(20), "
			+ "'PRODUCTDESCCOLORS' varchar(20), "
			+ "'PRODUCTDESCISOUTOFSTACK' int, "
			+ "'PRODUCTDESCPOSTFEE' float, "
			+ "'PRODUCTCATEGORYID' varchar(20))";
}
